SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 111. What is ROWID?
ROWID is a pseudo column attached to each row of a table. It is 18 characters long, blockno, rownumber are the components of ROWID.
Is it helpful?
Add Comment
View Comments
Ques 112. What is the fastest way of accessing a row in a table?
Using ROWID.
CONSTRAINTS
Is it helpful?
Add Comment
View Comments
Ques 113. What is an integrity constraint?
Integrity constraint is a rule that restricts values to a column in a table.
Is it helpful?
Add Comment
View Comments
Ques 114. What is referential integrity constraint?
Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table.
Is it helpful?
Add Comment
View Comments
Ques 115. What is the usage of SAVEPOINTS?
SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: